UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JCOX/8UnXNs4s+x9/9Ew67CaDLngNYe88Iq0vXHTEs0='
WHERE
key_id = '3cf3f4af0bb1a1d60bc71f9ee9f37f1dc0b4fb3d73f5146a24b15f542d731b5f'
AND (
token = 'JCOX/8UnXNs4s+x9/9Ew67CaDLngNYe88Iq0vXHTEs0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)