UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P96cXqshQJy9DxMylneav+MMdvrrL/85MmTapHdRork='
WHERE
key_id = '0d02737f51a9726333b84eb5c6ba7549cfcede2092050c4f4333463eceac8f1e'
AND (
token = 'P96cXqshQJy9DxMylneav+MMdvrrL/85MmTapHdRork='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)