UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0qjVllC4JTUnNgF3p7kktHJy1MwnavrGscOYwXHpAK4='
WHERE
key_id = '19b7808d9b99e90e40655b0dc3f369db013799962e2b65dcab555485a92b3ae9'
AND (
token = '0qjVllC4JTUnNgF3p7kktHJy1MwnavrGscOYwXHpAK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)