UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KRy4ZQp+z2LmgZRmy8dEClAeun3AmdNlOC3Lma4XHZQ='
WHERE
key_id = '9ccabe8ff96eb21da5799baec9138291a35fbd86c86f0fe28b2e3abe6c28a82f'
AND (
token = 'KRy4ZQp+z2LmgZRmy8dEClAeun3AmdNlOC3Lma4XHZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)