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