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