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