UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r+TSvbckDBaIEHQYjWmOUL+NOy6GraO2ujjKD2Fajzk='
WHERE
key_id = 'de99dcce3e03d4e3dd81825a22447caba32036fc2136244c2a5f2707bf7a3650'
AND (
token = 'r+TSvbckDBaIEHQYjWmOUL+NOy6GraO2ujjKD2Fajzk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)