UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tPBK1WleUhzkmO2D3vfE7YPQgLn1km7J+57Jyw9fu3c='
WHERE
key_id = '0976cd2306f7fe266385efe5c4a095ad748d0fdbe66342363e4123e282396bd5'
AND (
token = 'tPBK1WleUhzkmO2D3vfE7YPQgLn1km7J+57Jyw9fu3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)