UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pu5nb8e1cKGDA8e8jZI08lk5+xBi/lC041LykwHKnoU='
WHERE
key_id = 'cd1185d19723e69774d729e0164c87385c8db20dd727423bb72373e17be94cdf'
AND (
token = 'pu5nb8e1cKGDA8e8jZI08lk5+xBi/lC041LykwHKnoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)