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