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