UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZDR4tlU7SfAEwRK9G3MiNfYDdYTiC5bpRuXdkLiC8ZA='
WHERE
key_id = '7c8396ab27045d26389dad7d5d65a3096fb768dd0708dd17aade7c4c535a238d'
AND (
token = 'ZDR4tlU7SfAEwRK9G3MiNfYDdYTiC5bpRuXdkLiC8ZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)