UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't5WQLOHo5Q/NJhMinPgf5mzdVCfBZnW/VGsdMMedx0E='
WHERE
key_id = '0b7d5d72115b316839b802c8ce9b5a29be0e50b41aaca246b403cf62cd559507'
AND (
token = 't5WQLOHo5Q/NJhMinPgf5mzdVCfBZnW/VGsdMMedx0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)