UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G148HgxabTPZevkIoQ0gkudVUP0Da19xg11uxY6+ayo='
WHERE
key_id = '07c5dcd7797cee92862d1124c2405dbdb39438d4a75418f6e8f10755b9372b6f'
AND (
token = 'G148HgxabTPZevkIoQ0gkudVUP0Da19xg11uxY6+ayo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)