UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oTE/hUnqE/4m98bi0cKv46SuJK4Cmd+tGiCECEdyaRQ='
WHERE
key_id = 'b7a29da82b4fb07dd5716d05c314670703205aa81b23ca212e3ff013f285857f'
AND (
token = 'oTE/hUnqE/4m98bi0cKv46SuJK4Cmd+tGiCECEdyaRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)