UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gHc2dZohedRzQ/iuDIsa9jsCZC22qLxIcW/SgcQEtNE='
WHERE
key_id = 'bc470b74dbcf4646aed6767158dfaa00cf5a06d0f37852681b6b3495f3120d7c'
AND (
token = 'gHc2dZohedRzQ/iuDIsa9jsCZC22qLxIcW/SgcQEtNE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)