UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '55CDWXb27DxlbZZPdKNyquXiC2cQfgIhdw6RIXu0Yvk='
WHERE
key_id = 'f45247d338f66ef8add37c9bed481703c5509d0bb26cc3c282d07949ffe52cf5'
AND (
token = '55CDWXb27DxlbZZPdKNyquXiC2cQfgIhdw6RIXu0Yvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)