UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VEF4tJfMALBEKBKnbUkAoKtu8dCg72BhH8BPsdWRdc4='
WHERE
key_id = '6aeb20f482b84e4209bb090d3129a4520a78d3182242688253acf90ab8f5ae8c'
AND (
token = 'VEF4tJfMALBEKBKnbUkAoKtu8dCg72BhH8BPsdWRdc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)