UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8rWDTfJNCm9GQqKLg6uxH77lwLpaqF9JPufOjc77Yps='
WHERE
key_id = '1612d501031b503cc4d67531de1526c7fdcaa27aa5a286e39bf0b911c741e5fa'
AND (
token = '8rWDTfJNCm9GQqKLg6uxH77lwLpaqF9JPufOjc77Yps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)