UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sWfaZSCNnWjC5piCHYGi00UR0DlHJwJDGMT8/OKmvM4='
WHERE
key_id = 'b16cbc19f439c45f6de343a60541d664bdc8d6e3142ed799557de4feea9a7b5a'
AND (
token = 'sWfaZSCNnWjC5piCHYGi00UR0DlHJwJDGMT8/OKmvM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)