UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GNcTio4T551SLG3pHJMX1wN2QQZCggh8May26a+xdpA='
WHERE
key_id = '2aee746c57e14b9471690c0f31548f7e52b6b695023edbc3c3f2d226b3b9506d'
AND (
token = 'GNcTio4T551SLG3pHJMX1wN2QQZCggh8May26a+xdpA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)