UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nTfqBh7EQhCt8H3FzUzzWUpzdn5THg0iTu689N3Yx+8='
WHERE
key_id = 'b167fa2315253ed016cdcefbf02ee4bb5a88eab86e1cdd894cd7bacefa670a02'
AND (
token = 'nTfqBh7EQhCt8H3FzUzzWUpzdn5THg0iTu689N3Yx+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)