UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '92dz51AUlhl0qk/F0RYHnv6v1c+aJuTl6gEdE5WtmaE='
WHERE
key_id = '31b881dd76c2ad636fe6564698c55dc5dbf4b91505afa6e049d5e5fe0f2c10e1'
AND (
token = '92dz51AUlhl0qk/F0RYHnv6v1c+aJuTl6gEdE5WtmaE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)