UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gnQbu9OvpxYUu8JzBfTjAUJwKtdqwMMMgKhQnyW4Ewk='
WHERE
key_id = 'efeac6d0078f2442ce8fdd13c5a5ee9b6b888679c6c3dc5b3fbe7828ff6bd8d1'
AND (
token = 'gnQbu9OvpxYUu8JzBfTjAUJwKtdqwMMMgKhQnyW4Ewk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)