UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJCa+5KfquwZK9XDoYdpdyX75jTS3gRdxCqbCIQYQS4='
WHERE
key_id = 'a17aca2903b97060986a4162fc933229a76761202357fc23ef5714975cf5ad5c'
AND (
token = 'BJCa+5KfquwZK9XDoYdpdyX75jTS3gRdxCqbCIQYQS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)