UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PN1A1WE2l+DhvMaTlhH3xYX/ICH50qO5XbbYA78vTy8='
WHERE
key_id = 'c5ec44ea52b0c2358f71980bd5a4978f3441eab807c53e3f17698b87de9ba076'
AND (
token = 'PN1A1WE2l+DhvMaTlhH3xYX/ICH50qO5XbbYA78vTy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)