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