UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zU1P6Kr7ih824jSoW7xm0J7auGF7O5eT+o8kd1QrGZw='
WHERE
key_id = '7db03a0ea1644d084871f2b67d19134b3e5af944107e245918b793ad4f23c32d'
AND (
token = 'zU1P6Kr7ih824jSoW7xm0J7auGF7O5eT+o8kd1QrGZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)