UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PicsDxbHZ4s7F9tDP1zpvyY/f05kpzykthOKcbznFUo='
WHERE
key_id = 'd2e85f47be6f108cd992a16309192f2a9bb93bb201c7adbf0fb721c77402fe7b'
AND (
token = 'PicsDxbHZ4s7F9tDP1zpvyY/f05kpzykthOKcbznFUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)