UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bpRy4F5iosYqw8+vzNEWH1962569DEdRSUCkuH6gAq4='
WHERE
key_id = 'd85ac8795f8870afb4eaed42ce190495924b6241ab5f9004d0e3e08c17e46a7a'
AND (
token = 'bpRy4F5iosYqw8+vzNEWH1962569DEdRSUCkuH6gAq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)