UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ShB8kfGBXGIrMbWlQ09+L8x6WxBso2GFM2UQZXAHTvM='
WHERE
key_id = 'aef96645e6472d4695dbb737a283fd18fdb01c94e6557620d10b675dced23f4b'
AND (
token = 'ShB8kfGBXGIrMbWlQ09+L8x6WxBso2GFM2UQZXAHTvM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)